Interview Questions

1. SSAS objects include attribute________?

Options:

a. Measures

b. Measure group

c. Dimension

d. Cube names

Reveal Answer

2. Perspectives can be used to implement security in SSAS?

Options:

a. True

b. False

Reveal Answer

3. Proprietary Returns ________?

Options:

a. Multidimensional dataset

b. Tabular row set

c. A string that can be interpreted by a client application

d. None of these

Reveal Answer

4. What are the different types of Actions in SQL Server Analysis Services?

Options:

a. Drillthrough Actions

b. Reporting Actions

c. Standard Actions

d. All the above

Reveal Answer

5. How to display the Labels and Captions of various SSAS objects in different languages?

Options:

a. By using KPIs

b. By using Translations

c. All the above

d. None of these

Reveal Answer

6. In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.

Options:

a. Translation

b. Dimension translation

c. Dim translation

d. None of the mentioned

Reveal Answer

7. Point out the correct statement:

Options:

a. The collation and language information for the client computer is stored in the form of a locale identifier (LCID)

b. SQL Server 2008 Analysis Services also supports translations of cube objects

c. SQL Server 2000 Analysis Services supports translations of cube objects

d. None of the mentioned

Reveal Answer

Interview Questions and Answer

1. SSAS objects include attribute________?

2. Perspectives can be used to implement security in SSAS?

3. Proprietary Returns ________?

4. What are the different types of Actions in SQL Server Analysis Services?

5. How to display the Labels and Captions of various SSAS objects in different languages?

6. In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.

7. Point out the correct statement:

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources